CREATING LINE AND CLUSTRED CHART 2&3
14
Create line and clustered column chart for GPM% and YOY% by Segment
STPE 1- Copy and paste the previous line and clustered column chart.
STEP 2- Go to General, x position = 832, y
position = 468, width = 668, height = 339
STEP 3 - Remove month from the shared axis and drag and drop Segment from sales table
STEP 4- Go to format, click title change month to segment
Follow the GIF below to apply the above steps

Create line and clustered column chart for GPM% and YOY% by Category and subcategory
STPE 1- Copy and paste the previous line and clustered column chart.
STEP 2- Create hierarchy put subcategory under category so we can make drill through.
STEP 3 - Remove month from the shared axis and drag and drop category hierarchy from sales
STEP 4- Go to format, click title change month to segment.
Follow the GIF below to apply the above steps

Final Step we need to add YOY% tooltip for all 3 line and clustered column chart
Follow the GIF below to apply the above steps

EVERYTHING you wanted to know about Power BI tooltips